Entity DefinitionLogical Name : TemporaryPriceChange |
---|
Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
---|---|---|---|---|---|
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
SaleUnitAmount | The amount (either monetary or percent) to be used to change or replace the current selling price for a sale unit of the item. | RP_UN_TMP_PRC_CHN | MoneyShortRetail | decimal(7,2) | |
SaleUnitAmountTypeCode | A code to define how the temporary-price-change-sale-unit-amount is to be interpreted. Valid values include: PCT percent of current retail price to be added to or subtracted from the current retail to arrive at a selling price; AMT, flat monetary amount to be added to or subtracted from the current retail to arrive at a selling price; and AMTREPL, a retail sale unit price amount that is to replace the current selling price. | TY_UN_TMP_PRC_CHN | Code2 | char(2) |
Parent Entity | Verb Phrase | Child Entity |
---|---|---|
TemporaryPriceChange | changes price for | TemporaryPriceChangeItem |
ItemPriceMaintenance | can be a | TemporaryPriceChange |
Logical View |
---|
Logical 01300 - Item Price Maintenance View |
Logical 06700 - Event Scheduler View |